DDE Command Set ************************************************************************** * * * PART 1: DDE Request Commands * * * ************************************************************************** Command Command Action Parameter(s) Param Action ========================================================================== GETACCOUNTS: Get Open Accounts GETREG: Get Register M=mm Specify Month Y=yy Specify Year F=All Show all (no filter, default) F=Cleared Show Cleared F=Uncleared Show Uncleared F=Credit Show Credit F=Debit Show Debit Example Usages in WinWord: Gets entire register for current month: --------------------------------------- {dde WinCheck TUT GetReg} Gets May 91 Register: --------------------------------------- {dde WinCheck TUT GetReg,m=05,y=91} Gets May 91 Register, cleared trans only: --------------------------------------- {dde WinCheck TUT GetReg,m=05,y=91,f=cleared} Gets May 91 Register, cleared debits only: --------------------------------------- {dde WinCheck TUT GetReg,m=05,y=91,f=cleared,f=debit} Command Command Action Parameter(s) Param Action ========================================================================== GETCATEGORIES: Guess? none Example Usage in WinWord {dde WinCheck TUT GetCategories} Command Command Action Parameter(s) Param Action ========================================================================== GETCOMMON List Common R=All Show all Dates Common (default) Transactions R=ll-hh Show Commons between ll and hh days F=All Show both cleared and uncleared F=Cleared Show Cleared F=Uncleared Show Uncleared Example Usages in WinWord Gets all Common Transactions --------------------------------------- {dde WinCheck TUT GetCommon} Gets all Common Transactions that debit --------------------------------------- {dde WinCheck TUT GetCommon,f=debit} Gets all Common Transactions that happen from the 1st to the 15th of the month --------------------------------------- {dde WinCheck TUT GetCommon,r=1-15} Gets all Common Transactions that happen from the 1st to the 15th of the month, and credit the account --------------------------------------- {dde WinCheck TUT GetCommon,r=1-15,f=credit} ************************************************************************** * * * PART 2: DDE Execute Commands * * * * If a parameter has a space in it, use quotes. For example, * * * * P=Shorewood Apartments * * * * is incorrect. Use * * * * P="Shorewood Apartments" * * * ************************************************************************** Command Command Action Parameter(s) Param Action ========================================================================== WRITECHECK Write D=mm/dd/yy Specify Date a Check T=dddd.cc Specify Amt C=X Specify Cleared N=### Specify check Number P=ppppppp Specify Payee M=mmmmm Specify Memo1 M2=mmmmm Specify Memo2 L=ccccc:ssss Specify Category $T=n*ddd.cc Specify Split #n amount (max 32) $L=n*ddd.cc Specify Split #n category (max 32) TO=ttt "To" part of Address ADDR=sss Street Address CITY=ccc City STATE=ss State ZIP=zzzz Zip PRINT Prints this check Example: To make WinCheck write a check for 580.00 to shorewoods, category rent, on the current date, current check #: [WriteCheck:p="Shorewood Apartments",t=580.00,l=Rent] Example: To make WinCheck write a check for 580.00 to shorewoods, category rent, on the current date, current check #, and print it: [WriteCheck:p="Shorewood Apartments",t=580.00,l=Rent,print] Command Command Action Parameter(s) Param Action ========================================================================== CDEPOSIT Make a Same as WRITECHECK SDEPOSIT deposit Example: To make WinCheck make a deposit for 1000, split across "Band Income" and "Payroll", on May 15, 1991: [CDeposit:t=1000.00,$T=1*450.00,$L=1*"Band Income",$T=2*550.00,$L=2*Payroll, D=05/15/91] Command Command Action Parameter(s) Param Action ========================================================================== CMISC Make up your Same as WRITECHECK, but add: SMISC Own DESC=Description Example: To make WinCheck enter Service Fees for 6.50 on June 12, 1991. [CMisc:t=6.50,Desc="Service Fees",D=06/12/91] Command Command Action Parameter(s) Param Action ========================================================================== REGISTERADDON The App will register itself by using the following DDE Execute command: [RegisterAddOn:e="",d="",h="",c="",s=""] Where: This is the line WinCheck will pass to WinExec after it has been registered. The user will not need to re-install the app a second time. This is the text that goes on a menu line First handle is handle of application add-on Second handle is the DDE conversation handle so WinCheck can drive it if needed. This is the class name of the first handle above. Sanity check to make sure that the handle above has not been re-assigned to something else. This will be displayed in the status line Example: [RegisterAddOn:e="payroll.exe",d="Payroll Check",h="1412,1242",c="clsPayRoll",s="Payroll"] NOTE: The example program PAYROLL, written in Visual Basic demonstrates using the REGISTERADDON DDE Call.